/*
 Navicat Premium Dump SQL

 Source Server         : 122.51.2.190_3306
 Source Server Type    : MySQL
 Source Server Version : 80040 (8.0.40-0ubuntu0.22.04.1)
 Source Host           : 122.51.2.190:3306
 Source Schema         : ry

 Target Server Type    : MySQL
 Target Server Version : 80040 (8.0.40-0ubuntu0.22.04.1)
 File Encoding         : 65001

 Date: 09/03/2025 22:36:25
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user_t
-- ----------------------------
DROP TABLE IF EXISTS `user_t`;
CREATE TABLE `user_t` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户id',
  `nick` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户名称',
  `avatar_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '头像链接',
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '手机号码',
  `mobile2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '手机号码2',
  `emp_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '工号',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '邮箱',
  `state_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '手机号对应的国家号',
  `credit` int(10) unsigned zerofill DEFAULT '0000000000' COMMENT '积分',
  `createdAt` datetime DEFAULT NULL,
  `updatedAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user_t
-- ----------------------------
BEGIN;
INSERT INTO `user_t` (`id`, `nick`, `avatar_url`, `mobile`, `mobile2`, `emp_id`, `email`, `state_code`, `credit`, `createdAt`, `updatedAt`) VALUES ('315847245036527873', '金丽萍', NULL, NULL, NULL, NULL, NULL, NULL, 0000000000, '2025-02-25 10:07:48', '2025-02-25 10:07:48');
INSERT INTO `user_t` (`id`, `nick`, `avatar_url`, `mobile`, `mobile2`, `emp_id`, `email`, `state_code`, `credit`, `createdAt`, `updatedAt`) VALUES ('manager3282', '徐凯', NULL, NULL, NULL, NULL, NULL, NULL, 0000000060, '2025-02-24 00:00:00', '2025-02-24 00:00:00');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
